﻿CREATE TABLE [maint].[DeviceHeaders] (
    [DeviceName]             [sysname]        NOT NULL,
    [BackupName]             NVARCHAR (128)   NULL,
    [BackupDescription]      NVARCHAR (255)   NULL,
    [BackupType]             SMALLINT         NULL,
    [ExpirationDate]         DATETIME         NULL,
    [Compressed]             BIT              NULL,
    [Position]               SMALLINT         NULL,
    [DeviceType]             TINYINT          NULL,
    [UserName]               NVARCHAR (128)   NULL,
    [ServerName]             NVARCHAR (128)   NULL,
    [DatabaseName]           NVARCHAR (128)   NULL,
    [DatabaseVersion]        INT              NULL,
    [DatabaseCreationDate]   DATETIME         NULL,
    [BackupSize]             NUMERIC (20)     NULL,
    [FirstLSN]               NUMERIC (25)     NULL,
    [LastLSN]                NUMERIC (25)     NULL,
    [CheckpointLSN]          NUMERIC (25)     NULL,
    [DatabaseBackupLSN]      NUMERIC (25)     NULL,
    [BackupStartDate]        DATETIME         NULL,
    [BackupFinishDate]       DATETIME         NULL,
    [SortOrder]              SMALLINT         NULL,
    [CodePage]               SMALLINT         NULL,
    [UnicodeLocaleId]        INT              NULL,
    [UnicodeComparisonStyle] INT              NULL,
    [CompatibilityLevel]     TINYINT          NULL,
    [SoftwareVendorId]       INT              NULL,
    [SoftwareVersionMajor]   INT              NULL,
    [SoftwareVersionMinor]   INT              NULL,
    [SoftwareVersionBuild]   INT              NULL,
    [MachineName]            NVARCHAR (128)   NULL,
    [Flags]                  INT              NULL,
    [BindingID]              UNIQUEIDENTIFIER NULL,
    [RecoveryForkID]         UNIQUEIDENTIFIER NULL,
    [Collation]              NVARCHAR (128)   NULL,
    [FamilyGUID]             UNIQUEIDENTIFIER NULL,
    [HasBulkLoggedData]      BIT              NULL,
    [IsSnapshot]             BIT              NULL,
    [IsReadOnly]             BIT              NULL,
    [IsSingleUser]           BIT              NULL,
    [HasBackupChecksums]     BIT              NULL,
    [IsDamaged]              BIT              NULL,
    [BeginsLogChain]         BIT              NULL,
    [HasIncompleteMetaData]  BIT              NULL,
    [IsForceOffline]         BIT              NULL,
    [IsCopyOnly]             BIT              NULL,
    [FirstRecoveryForkID]    UNIQUEIDENTIFIER NULL,
    [ForkPointLSN]           NUMERIC (25)     NULL,
    [RecoveryModel]          NVARCHAR (60)    NULL,
    [DifferentialBaseLSN]    NUMERIC (25)     NULL,
    [DifferentialBaseGUID]   UNIQUEIDENTIFIER NULL,
    [BackupTypeDescription]  NVARCHAR (60)    NULL,
    [BackupSetGUID]          UNIQUEIDENTIFIER NULL,
    [CompressedBackupSize]   BIGINT           NULL,
    [Containment]            TINYINT          NULL,
    [KeyAlgorithm]           NVARCHAR (32)    NULL,
    [EncryptorThumbprint]    VARBINARY (20)   NULL,
    [EncryptorType]          NVARCHAR (32)    NULL
);





